UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'V78tKgtYvttkv/BVl0youhaAgU9irS6sZE3x3zdrGt0='
WHERE
key_id = '4c3914b2304ba7632f75895b9a2f70fa2a0190b5594ce088b056abeeeac59972'
AND (
token = 'V78tKgtYvttkv/BVl0youhaAgU9irS6sZE3x3zdrGt0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)