UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8HxZ8m9w9aMkqgjZeoXMrOJe7hpE0gD69vHcfOyS9n0='
WHERE
key_id = 'b2012191d2cdde80f1179291257ffd0a693a9e92962021b60322d1aba73377b3'
AND (
token = '8HxZ8m9w9aMkqgjZeoXMrOJe7hpE0gD69vHcfOyS9n0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)