SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'a470a4de8c07a0ad024d6ce2d43e6bae90b2a4614dffa93c67a37309f4a3cea2' 
  AND token = '5BhUOQgsbc0rnp1n9Ue9jBrWtPbGpiKN+ahyJ0z+sqA=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00018

JSON explain

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