UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RGV0QX+eh4LOIGNKNMaydIs4Dq88C81OV+xY3QLVHu0='
WHERE
key_id = '8e5ae58f10f1d98d535b78ac91189735bde0e954cc68819c8cd9d0ea969c40d4'
AND (
token = 'RGV0QX+eh4LOIGNKNMaydIs4Dq88C81OV+xY3QLVHu0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)