UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C6lEqgEpo+P+LdRzQPfJNbmKECHpNwfhokc6QMHVKbE='
WHERE
key_id = '27de62cc7221241e2950276f8554986885566a549b0c2b78fbe62ab357ec76dd'
AND (
token = 'C6lEqgEpo+P+LdRzQPfJNbmKECHpNwfhokc6QMHVKbE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)