UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XGSjGe6jZfaXYudnm6nQoeLXD4Czqi69fb9idCZCN/o='
WHERE
key_id = '4df1b0cf56870b9fa205e7eee92df1c769adba92bd5104adca2d2dc011f8e37d'
AND (
token = 'XGSjGe6jZfaXYudnm6nQoeLXD4Czqi69fb9idCZCN/o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)