UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'RyYwXPYow4pXm6jqEbuP/Q32JYzJ2KfPXff+boVSLUs=' 
WHERE 
  key_id = 'c799cd61985dd7769d2bf69f505519024265ade7af9d7e61f9da3317c3b5ddb3' 
  AND (
    token = 'RyYwXPYow4pXm6jqEbuP/Q32JYzJ2KfPXff+boVSLUs=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00047