UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'N3x2o0H9ss5xXBgQo2w2rQW4GG5gAzudcpeQunC4oFQ=' 
WHERE 
  key_id = '9253f539316b9ba689f04565eee81acf374234119b9dfded90a22eb584d5725f' 
  AND (
    token = 'N3x2o0H9ss5xXBgQo2w2rQW4GG5gAzudcpeQunC4oFQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00038