UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7IjNrfGlQSzH9J4HrNzMdgpc4TzUM3dKmovOvO+oGlw='
WHERE
key_id = '79f1bf80df16c4a84d5c82289148427b858be5532f486519048e036cd9255f8f'
AND (
token = '7IjNrfGlQSzH9J4HrNzMdgpc4TzUM3dKmovOvO+oGlw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)