UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZHM/X4hPVjq1SAayKqMuF/6yaEqU9qTr3zmDxY5kopM='
WHERE
key_id = 'c0269405e9f335d16ee663d549cc6755871a9025492e6ccb41dec36345553526'
AND (
token = 'ZHM/X4hPVjq1SAayKqMuF/6yaEqU9qTr3zmDxY5kopM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)