UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '6nxPn58xvrIvQ3AD/2yHLH+/fE0iivdjO0Zu3alo6dw=' 
WHERE 
  key_id = 'fa4f2446188fa54209db13a2fd87d372c864a4657ff2431e22331af0e13db0d0' 
  AND (
    token = '6nxPn58xvrIvQ3AD/2yHLH+/fE0iivdjO0Zu3alo6dw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021