SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '049b569ec385ef359d5eab362c74f9acf15f13ecf188cd7b45fc16e7a610e8f0' 
  AND token = 'lRvxjVoCegcfzHmBKRyIc9JGW1Jr5gERpQ6/YfAaFK4=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00025

JSON explain

{
  "query_block": {
    "select_id": 1,
    "message": "no matching row in const table"
  }
}