UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZwlHYq8Js+1FykDL4xcHhuOUlR9S/DFk2vbTdWEzhyw='
WHERE
key_id = 'bc048d67672c6e995a715615cd4492e2eeda1f763049677e897ee27561784801'
AND (
token = 'ZwlHYq8Js+1FykDL4xcHhuOUlR9S/DFk2vbTdWEzhyw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)