UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VJNalv06ReV8Uo4SGLqDT7HlfPI3LrNc1TZTcwVdjC4='
WHERE
key_id = '9ffc414664bc1954e127ca5d92c14128cdf1a4e3d67e9200ee7ece502d842821'
AND (
token = 'VJNalv06ReV8Uo4SGLqDT7HlfPI3LrNc1TZTcwVdjC4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)