UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '1wepNulI9D5lQz6m5nG3UXibt3ZZPLFXSklg2Nn7+ds=' 
WHERE 
  key_id = 'bb21ff8b19f38c76709ab074f9772000244a9a47ab6e9588e4afff1c7c4ac8e7' 
  AND (
    token = '1wepNulI9D5lQz6m5nG3UXibt3ZZPLFXSklg2Nn7+ds=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00024