UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jCR9z0OuaZvGH2ruqElCvfF0Ao0iOJWs8+xisIEAEwc='
WHERE
key_id = 'd5b7ae4bb9ad9e4df02d245bedbde0c2ea7bebf3f65c084b57e81788c76eb0e6'
AND (
token = 'jCR9z0OuaZvGH2ruqElCvfF0Ao0iOJWs8+xisIEAEwc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)