SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '980ce1de8d2375a25980957e731b17b7087775a22f4eaf002833de75819d214a' 
  AND token = 'XlkH9uW0ZBV6sVFo1sq4S8OUH22Rfe1GKRve79ZkGjc=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00052

JSON explain

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