UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Os5DAioW8OZ9sKU4O81NMA8e2Ya/P66lFbtXLt02RTo='
WHERE
key_id = 'c6e05df40f763afbdbadec679af4e822ff0fe4d95c3395954acd7213974d6048'
AND (
token = 'Os5DAioW8OZ9sKU4O81NMA8e2Ya/P66lFbtXLt02RTo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)