UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9aNDJoPDGJ53bMaJO2BcLB5kvIdoONZnEjxqY0h8BF4='
WHERE
key_id = '1d38e6cb42d1e042bb49970fd92261d63ecfe99e8b000d959f68502993e7138d'
AND (
token = '9aNDJoPDGJ53bMaJO2BcLB5kvIdoONZnEjxqY0h8BF4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)