UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QSf30hUX7mjIDlvMAfJTA5jE2zxXGmaB2Bae8dHLb04='
WHERE
key_id = 'beab6f471ec4f0a1a5ea021a23e077ef1d643aa9049005bb832ba33abdbf080a'
AND (
token = 'QSf30hUX7mjIDlvMAfJTA5jE2zxXGmaB2Bae8dHLb04='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)