UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HF4wL4JFpYSlPAD4X7yab2DEEoU6HrzjDLw/B+W3krw='
WHERE
key_id = 'efc9cbe010d87bd57e0004d25622caf877c66af262c7b89261db3a01c290256d'
AND (
token = 'HF4wL4JFpYSlPAD4X7yab2DEEoU6HrzjDLw/B+W3krw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)