UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 't0hz85TRPOumAUgduZsZhpan0c94ReYTIVUWANjhgaw='
WHERE
key_id = '78247c0f01d968cc9806a51964b177c4aeaa35665abe058de17a1c69d2313eac'
AND (
token = 't0hz85TRPOumAUgduZsZhpan0c94ReYTIVUWANjhgaw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)