UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WnwoNErVSAHwDRVDrL14JnDggWocfORKKWK0YSjoE78='
WHERE
key_id = 'e2c3a98bc19391c3d44f3ab883e519374f0caa62f8fb43e8e9f298b39a98af1b'
AND (
token = 'WnwoNErVSAHwDRVDrL14JnDggWocfORKKWK0YSjoE78='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)