UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cN7Jz/AVDiW4plrP7ZAmwofHhZpoDWRpfJ1p1tZzdpo='
WHERE
key_id = '511e53df508a841d34083eb5a109046815039ccd70f07ccdc42b872aced9faa3'
AND (
token = 'cN7Jz/AVDiW4plrP7ZAmwofHhZpoDWRpfJ1p1tZzdpo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)