UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pYPmVeg/xgiAXNS7Q4ikagbdNSBFOGTq8vgmZCZXK+I='
WHERE
key_id = 'b889d79cf1c6b2fe0d4d1a13ddeb54c241e1bff1f73e1959fd57eea2a56749d6'
AND (
token = 'pYPmVeg/xgiAXNS7Q4ikagbdNSBFOGTq8vgmZCZXK+I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)