UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'NKCSwZhWQZSeT/6s3OP2IxbSk/kGBq/VblOJJsP77Cc=' 
WHERE 
  key_id = 'bf29dad516028af7a572c23c7281bcd3b00d64632dd769ab8ea738883668c3dc' 
  AND (
    token = 'NKCSwZhWQZSeT/6s3OP2IxbSk/kGBq/VblOJJsP77Cc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00025