UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0HvP511hS3eEismflHztL11KxM4UwrSOFe4InvUGn3Y='
WHERE
key_id = 'd07b5152d91b07afd66fd15aa1d4a6cdec22aeb8adc4a35344db45572ca4ae08'
AND (
token = '0HvP511hS3eEismflHztL11KxM4UwrSOFe4InvUGn3Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)