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