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