UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hc4aid+1gIzreuTQdJFMOgJQAZVJDCgChX0wXTfOQWQ='
WHERE
key_id = '9fad7feac8d6d9b8bceeabf48d7f3493a7c69be69bf1e85c8ec3967da08cbf06'
AND (
token = 'hc4aid+1gIzreuTQdJFMOgJQAZVJDCgChX0wXTfOQWQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)