UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p3YYb0uhU6k6igyHkK3rY6E0G5OPtvEgaSrd/u/8Zg0='
WHERE
key_id = 'd86c04d163f00542b9f82da4c88ea0b13509c96901aa01b29f3512ea8a1a2899'
AND (
token = 'p3YYb0uhU6k6igyHkK3rY6E0G5OPtvEgaSrd/u/8Zg0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)