UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sq9cX5NufRFpVejgyslbi+bPZdJUX3ADJwi+20Vf8RQ='
WHERE
key_id = '27ccd83cd6d4432bac980ac3a164a72037f07a2f6349be3a5bb57ce4a0a1e055'
AND (
token = 'sq9cX5NufRFpVejgyslbi+bPZdJUX3ADJwi+20Vf8RQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)