UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'YzF1b8GI/fXSTokO9dFPvB8+15McPbICQf3C3jvaMaM=' 
WHERE 
  key_id = '6615f380755e656a1e528dd7a78832bb81c7c4f5186ee64def9b0a4697de2d68' 
  AND (
    token = 'YzF1b8GI/fXSTokO9dFPvB8+15McPbICQf3C3jvaMaM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027