UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5p/7R1zGGKYExoXQfvQ0sj7HV//8ymW8GReWMmAA8yE='
WHERE
key_id = '07463412bf29d1149a6cadf6b79d44542b2ccfe72f0f92215380f8b9efa5fbf5'
AND (
token = '5p/7R1zGGKYExoXQfvQ0sj7HV//8ymW8GReWMmAA8yE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)