UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X//FwpMoVRAq77MCUzcaytZb3hzKfo8R1A2Y0rymzKo='
WHERE
key_id = 'd7ab990b0dfb8869352d2974356fc29a5a59f149084062a543e6d40ea5e5c2c6'
AND (
token = 'X//FwpMoVRAq77MCUzcaytZb3hzKfo8R1A2Y0rymzKo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)